CREATE TABLE [dbo].[u_f3_00_varios]
(
[Id] [int] NOT NULL,
[Idconstruccion] [int] NOT NULL,
[Planta] [int] NULL,
[Local] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[idTipoLocal] [int] NULL,
[idTipoLocalPedagogico] [tinyint] NULL,
[otroTipoLocal] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[otroTipoLocalPedagogico] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rtaDestinoAulaComun] [int] NULL,
[otroDestinoAulaComun] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[largoPred] [int] NULL,
[anchoPred] [int] NULL,
[diametro] [int] NULL,
[altMax] [int] NULL,
[altMin] [int] NULL,
[idTipoTecho] [int] NULL,
[idEstadoTecho] [int] NULL,
[idTipoCielorraso] [int] NULL,
[idEstadoCielorraso] [int] NULL,
[idTipoParedTabique] [int] NULL,
[idEstadoParedTabique] [int] NULL,
[idTipoPiso] [int] NULL,
[idEstadoPiso] [int] NULL,
[idTipoRevestimiento] [int] NULL,
[idEstadoRevestimiento] [int] NULL,
[idRevoque] [int] NULL,
[idEstadoRevoque] [int] NULL,
[idPintura] [int] NULL,
[idEstadoPintura] [int] NULL,
[idRtaIluminacionNat] [int] NULL,
[idRtaVentilacionExt] [int] NULL,
[idRtaVentilacionCruz] [int] NULL,
[idRtaVentilacionForz] [int] NULL,
[supIluminacion] [int] NULL,
[supVentilacion] [int] NULL,
[idRtaSistOsc] [int] NULL,
[idtiposistrobo] [int] NULL,
[4_1_PuertaAbrirCant] [int] NULL,
[4_1_PuertaAbrirEst] [int] NULL,
[4_1_PuertaDobleCant] [int] NULL,
[4_1_PuertaDobleEst] [int] NULL,
[4_1_PuertaCorredCant] [int] NULL,
[4_1_PuertaCorredEst] [int] NULL,
[4_1_PuertaSinCarpCant] [int] NULL,
[puertas_us_administ] [int] NULL,
[4_2_VentAbrirCant] [int] NULL,
[4_2_VentAbrirEst] [int] NULL,
[4_2_VentCorredCant] [int] NULL,
[4_2_VentCorredEst] [int] NULL,
[4_2_VentVetiluzCant] [int] NULL,
[4_2_VentVetiluzEst] [int] NULL,
[4_2_VentPanosCant] [int] NULL,
[4_2_VentPanosEst] [int] NULL,
[4_2_VentGuillotCant] [int] NULL,
[4_2_VentGuillotEst] [int] NULL,
[ventanas_us_administ] [int] NULL,
[4_3_ClaraboyaCant] [int] NULL,
[4_3_ClaraboyaEst] [int] NULL,
[6_1_VentTechoCant] [int] NULL,
[6_1_VentParedCant] [int] NULL,
[6_1_AireAcondIndCant] [int] NULL,
[6_1_AireAcondCentEst] [int] NULL,
[6_1_AcondFrioTieneEst] [int] NULL,
[6_2_CalefGasCant] [int] NULL,
[6_2_CalefElectCant] [int] NULL,
[6_2_AireAcondIndCant] [int] NULL,
[6_2_AireAcondCentEst] [int] NULL,
[6_2_SalamandraCant] [int] NULL,
[6_2_AcondCalorTieneEst] [int] NULL,
[8_IdRtaPoseeAguaFria] [int] NULL,
[8_IdDescripAguaFria] [int] NULL,
[8_IdRtaFuncAguaFria] [int] NULL,
[8_IdMotNoFuncAguaFria] [int] NULL,
[8_IdRtaPoseeAguaCal] [int] NULL,
[8_IdDescripAguaCal] [int] NULL,
[8_IdRtaFuncAguaCal] [int] NULL,
[8_IdMotNoFuncAguaCal] [int] NULL,
[8_IdRtaPoseeDistIntGas] [int] NULL,
[8_IdDescripDistIntGas] [int] NULL,
[8_IdRtaFuncDistIntGas] [int] NULL,
[8_IdMotNoFuncDistIntGas] [int] NULL,
[8_IdRtaPoseeDistElect] [int] NULL,
[8_IdDescripDistElect] [int] NULL,
[8_IdRtaFuncDistElect] [int] NULL,
[8_IdMotNoFuncDistElect] [int] NULL,
[8_IdRtaPoseeCabEstruc] [int] NULL,
[8_IdDescripCabEstruc] [int] NULL,
[8_IdRtaFuncCabEstruc] [int] NULL,
[8_IdRtaPoseeFuerMotriz] [int] NULL,
[8_IdDescripFuerMotriz] [int] NULL,
[8_IdRtaFuerMotrizFunc] [int] NULL,
[8_IdRtaOtroPosee] [int] NULL,
[9_CantCalefGas] [int] NULL,
[9_CantFuncCalefGas] [int] NULL,
[9_CantCalefElect] [int] NULL,
[9_CantFuncCalefElect] [int] NULL,
[9_CantTermotanque] [int] NULL,
[9_CantFuncTermotanque] [int] NULL,
[9_CantCocIndust] [int] NULL,
[9_CantFuncCocIndust] [int] NULL,
[9_CantCocGasDom] [int] NULL,
[9_CantFuncCocGasDom] [int] NULL,
[9_CantCocElectDom] [int] NULL,
[9_CantFuncCocElectDom] [int] NULL,
[9_CantAnafe] [int] NULL,
[9_CantFuncAnafe] [int] NULL,
[9_CantCocEcon] [int] NULL,
[9_CantFuncCocEcon] [int] NULL,
[9_CantHorno] [int] NULL,
[9_CantFuncHorno] [int] NULL,
[9_CantFogon] [int] NULL,
[9_CantFuncFogon] [int] NULL,
[9_CantHeladera] [int] NULL,
[9_CantFuncHeladera] [int] NULL,
[9_CantFreezer] [int] NULL,
[9_CantFuncFreezer] [int] NULL,
[9_CantMicroondas] [int] NULL,
[9_CantFuncMicroondas] [int] NULL,
[9_CantOtro] [int] NULL,
[9_CantFuncOtro] [int] NULL,
[10_CantInodPed] [int] NULL,
[10_CantFuncInodPed] [int] NULL,
[10_IdEstadoInodPed] [int] NULL,
[10_CantInodTurca] [int] NULL,
[10_CantFuncInodTurca] [int] NULL,
[10_IdEstadoInodTurca] [int] NULL,
[10_CantInodBaby] [int] NULL,
[10_CantFuncInodBaby] [int] NULL,
[10_IdEstadoInodBaby] [int] NULL,
[10_CantInodDiscap] [int] NULL,
[10_CantFuncInodDiscap] [int] NULL,
[10_IdEstadoInodDiscap] [int] NULL,
[10_CantMigMural] [int] NULL,
[10_CantFuncMigMural] [int] NULL,
[10_IdEstadoMigMural] [int] NULL,
[10_CantMigPalang] [int] NULL,
[10_CantFuncMigPalang] [int] NULL,
[10_IdEstadoMigPalang] [int] NULL,
[10_CantMigCanalet] [int] NULL,
[10_CantFuncMigCanalet] [int] NULL,
[10_IdEstadoMigCanalet] [int] NULL,
[10_CantBachaAdult] [int] NULL,
[10_CantFuncBachaAdult] [int] NULL,
[10_IdEstadoBachaAdult] [int] NULL,
[10_CantBachaInic] [int] NULL,
[10_CantFuncBachaInic] [int] NULL,
[10_IdEstadoBachaInic] [int] NULL,
[10_CantBachaDisc] [int] NULL,
[10_CantFuncBachaDisc] [int] NULL,
[10_IdEstadoBachaDisc] [int] NULL,
[10_CantPiletAdult] [int] NULL,
[10_CantFuncPiletAdult] [int] NULL,
[10_IdEstadoPiletAdult] [int] NULL,
[10_CantPiletInic] [int] NULL,
[10_CantFuncPiletInic] [int] NULL,
[10_IdEstadoPiletInic] [int] NULL,
[10_CantBebedero] [int] NULL,
[10_CantFuncBebedero] [int] NULL,
[10_IdEstadoBebedero] [int] NULL,
[10_CantBarrDisc] [int] NULL,
[10_CantFuncBarrDisc] [int] NULL,
[10_IdEstadoBarrDisc] [int] NULL,
[10_CantLetrina] [int] NULL,
[10_CantFuncLetrina] [int] NULL,
[10_CantDuchas] [int] NULL,
[10_CantFuncDuchas] [int] NULL,
[10_IdEstadoDuchas] [int] NULL,
[10_CantBidet] [int] NULL,
[10_CantFuncBidet] [int] NULL,
[10_IdEstadoBidet] [int] NULL,
[10_CantOtro] [int] NULL,
[10_CantFuncOtro] [int] NULL,
[observaciones] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[localSinUso] [int] NULL,
[superficie] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f3_00_varios] ADD CONSTRAINT [PK_u_f3_00_varios] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_f3_00_varios] WITH NOCHECK ADD CONSTRAINT [FK_u_f3_00_varios_u_f2_00_varios] FOREIGN KEY ([Idconstruccion]) REFERENCES [dbo].[u_f2_00_varios] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f3_00_varios] WITH NOCHECK ADD CONSTRAINT [FK_u_f3_00_varios_u_tp_tipo_local] FOREIGN KEY ([idTipoLocal]) REFERENCES [dbo].[u_tp_tipo_local] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_f3_00_varios] NOCHECK CONSTRAINT [FK_u_f3_00_varios_u_f2_00_varios]
GO
ALTER TABLE [dbo].[u_f3_00_varios] NOCHECK CONSTRAINT [FK_u_f3_00_varios_u_tp_tipo_local]
GO
